|
Using TextPipe you can insert processed data directly into a database without having to run a second program. The database filter assumes that incoming text is one or more SQL commands, each separated by a semi-colon. To insert data into a database, the text generally looks like this:
(This was created using a database filter set to generate a SQL Insert Script for table 'products', with Trial Run Input of 'select product_id,productname from products') In the example above we are inserting into the 'products' table, into the fields product_id and productname. Let's assume that our data is in CSV (Comma Separated Value) form:
We need to make some simple changes to it to manipulate it into the SQL Insert Script form.
|
Contact
Us
Support
Community
Tutorials and User Guides (online) |